﻿IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[DataSystemType])
BEGIN
	INSERT INTO [dbo].[DataSystemType]([DataSystemTypeId], [DataSystemTypeName])
	SELECT -1, 'Unknown' UNION ALL
	SELECT 0, 'Microsoft SQL Server' UNION ALL
	SELECT 1, 'Microsoft Azure SQL Data Warehouse' UNION ALL
	SELECT 2, 'Oracle' UNION ALL
	SELECT 3, 'DB2' UNION ALL
	SELECT 4, 'SAP' UNION ALL
	SELECT 5, 'Flat File' UNION ALL
	SELECT 6, 'XML File'
END